Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_ADVISOR_RECOMMENDATIONS

`DBA_ADVISOR_RECOMMENDATIONS` displays the results of an analysis of all recommendations in the database. A recommendation can have multiple actions associated with it. Actions are described in the `DBA_ADVISOR_ACTIONS` view. A recommendation also points to a set of rationales that present a justification/reasoning for that recommendation. These rationales are in the `DBA_ADVISOR_RATIONALE` view.

Related View

`USER_ADVISOR_RECOMMENDATIONS` displays the results of an analysis of the recommendations owned by the current user. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` |  | Owner of the task
`REC_ID` | `NUMBER` | `NOT NULL` | Unique identifier of the recommendation
`TASK_ID` | `NUMBER` | `NOT NULL` | Task that owns the recommendation
`TASK_NAME` | `VARCHAR2(30)` |  | Name of the task
`FINDING_ID` | `NUMBER` |  | Unique identifier of the finding
`TYPE` | `VARCHAR2(30)` |  | Type of the recommendation
`RANK` | `NUMBER` |  | Ranking, in terms of importance, within the set of recommendations generated for the task
`PARENT_REC_IDS` | `VARCHAR2(4000)` |  | Comma-separated list of the recommendation IDs of the parent recommendations. If this column is nonzero, then the recommendation depends on the parents, and cannot be accepted if the parents are not accepted.
`BENEFIT_TYPE` | `VARCHAR2(4000)` |  | Describes the benefit obtained by carrying out the recommendation If there is a set of parents for the recommendation, then the benefit is the cumulative benefit (the improvement in system performance when this and all prior parent recommendations are accepted). If there are no parents, then this is the improvement when the recommendation is accepted, independent of other recommendations.
`BENEFIT` | `NUMBER` |  | Calculated benefit value
`ANNOTATION_STATUS` | `VARCHAR2(11)` |  | When a task is complete, the recommendations are marked `ACCEPT`. The status can be changed later using the `MARK_RECOMMENDATION` procedure: `ACCEPT` - Current recommendation is ready to implement. This recommendation can also be used as advice for future analysis operations. `REJECT` - Current recommendation is not acceptable to the user, and therefore will be excluded from any implementation scripts. This recommendation can also be used as advice for future analysis operations. `IGNORE` - Though not rejected, the current recommendation will be ignored when generating scripts and will never be used as advice to future analysis operations.
`FLAGS` | `NUMBER` |  | Advisor-specific flags

See Also: "USER_ADVISOR_RECOMMENDATIONS"